AllowAdditions Property

       

GroupLevel object:  Returns or sets a Boolean that represents whether the user can add records to the specified group. Set this property to False to prevent users from adding records to a group. The default value is True. Read/write.

PivotView object: Returns or sets a Boolean that represents whether the user can add a new record to the detail area of a PivotTable list. Set this property to True to allow the user to insert new records. The default value if False. Read/write.

expression.AllowAdditions

expression   Required. An expression that returns a GroupLevel or PivotView object.

Remarks

When this property is set to True, an asterisk (*) will be displayed in a blank row in the detail area. Any new records added to the detail area of a PivotTable list are also added to the source database.

You cannot add records to the detail area of the PivotTable list if the source recordset does not allow insertions.

Example

This example allows the user to add new records to the detail area of PivotTable1.

PivotTable1.ActiveView.AllowAdditions = True